Open topic with navigation

Configuration Databases

Flow stores its configuration within a Configuration Database. A configuration database is a Microsoft SQL Server database.

By default Flow installs an instance of Microsoft SQL Server 2005 Express. This SQL Server instance is called <computername>\Flow. This SQL Server instance has a default administrator account with the name sa. The password is F1owsq1!

During installation a default configuration database is created under the <computername>\Flow SQL Server instance. You can create further configuration databases by following these steps.

1. Create a blank SQL Server database

To access the SQL Server instance and manage the databases you will need to install Microsoft SQL Management Console. Please refer to the section See "Installing Microsoft SQL Management Console" for information on installing this console. Please refer to the Microsoft SQL Management Console help files for information about using SQL Server.

2. Configure a System Connection pointing to the database

To access a configuration database you will need to setup a System Connection pointing to that database. Please refer to the topic See "System Connections"

3. Start Flow and upgrade the database

All configuration databases start life as a blank database. When you first login to the database with Flow it will upgrade the database with the necessary tables. Please refer to the topic See "Upgrading a configuration database"

It is possible to use SQL Compact for a configuration database. This is only used in cases where Flow is embedded into another application or it is not possible to install Microsoft SQL Server. For more information consult your Flow accredited partner.